[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '7' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109 | 14.4231 | 1974-02-24 | Marketing | mary0@adventure-works.com | Mary Gibson | 531-555-0183 | 767955365 | Mary | F | 2020-06-25 | Gibson | adventure-works\mary0 | M | E | 7 | 2 | 531-555-0183 | | 43 | 2020-06-25 | Current | Marketing Specialist | 46 |
| 207 | 14.4231 | 1997-07-18 | Marketing | terry0@adventure-works.com | Terry Eminhizer | 138-555-0118 | 243322160 | Terry | M | 2020-08-13 | Eminhizer | adventure-works\terry0 | M | J | 7 | 2 | 138-555-0118 | | 42 | 2020-08-13 | Current | Marketing Specialist | 44 |
| 2 | 13.4615 | 1998-10-14 | Marketing | kevin0@adventure-works.com | Kevin Brown | 150-555-0189 | 253022876 | Kevin | M | 2018-07-09 | Brown | adventure-works\kevin0 | S | F | 7 | 2 | 150-555-0189 | | 41 | 2018-07-09 | Current | Marketing Assistant | 42 |
| 122 | 14.4231 | 1990-11-29 | Marketing | jill0@adventure-works.com | Jill Williams | 510-555-0121 | 72636981 | Jill | F | 2020-07-01 | Williams | adventure-works\jill0 | M | A | 7 | 2 | 510-555-0121 | | 43 | 2020-07-01 | Current | Marketing Specialist | 47 |
| 48 | 14.4231 | 1998-11-01 | Marketing | sariya0@adventure-works.com | Sariya Harnpadoungsataya | 399-555-0176 | 95958330 | Sariya | M | 2020-05-25 | Harnpadoungsataya | adventure-works\sariya0 | S | E | 7 | 2 | 399-555-0176 | | 42 | 2020-05-25 | Current | Marketing Specialist | 45 |
| 273 | 13.4615 | 1986-08-28 | Marketing | wanida0@adventure-works.com | Wanida Benshoof | 708-555-0141 | 323403273 | Wanida | F | 2022-06-20 | Benshoof | adventure-works\wanida0 | M | M | 7 | 2 | 708-555-0141 | | 40 | 2022-06-20 | Current | Marketing Assistant | 41 |
| 275 | 14.4231 | 1989-08-17 | Marketing | john5@adventure-works.com | John Wood | 486-555-0150 | 222969461 | John | M | 2022-07-21 | Wood | adventure-works\john5 | S | L | 7 | 2 | 486-555-0150 | | 44 | 2022-07-21 | Current | Marketing Specialist | 48 |
| 276 | 13.4615 | 1989-07-12 | Marketing | mary2@adventure-works.com | Mary Dempsey | 124-555-0114 | 52541318 | Mary | F | 2022-07-28 | Dempsey | adventure-works\mary2 | S | A | 7 | 2 | 124-555-0114 | | 41 | 2022-07-28 | Current | Marketing Assistant | 43 |
Generated 2025-12-11 15:34:45.064 UTC